Quick Excel Modeling

Click the Add Excel button in the Data Discovery/Modeling tab to open this dialog.

Use this dialog to add a new Excel file to the current data model, as described below.

• Upload a single Excel file from the local computer. Or alternatively, specify an Excel file in a shared folder.
• Select the desired Excel sheets to use (optional).
• Edit relationships (optional).
• At the end of the process, control is returned to the Data Discovery/Modeling tab.

Example of Excel File Upload

Click Browse and select an Excel file.

By default, all sheets are selected. The user can deselect sheets in the left-hand column and can also edit relationships in the right-hand panel.